package com.ruoyi.system.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.JingfeiDept;
import com.ruoyi.system.domain.JingfeiZhuanjiaMonth;
import org.apache.ibatis.annotations.Param;

/**
 * jingfeideptMapper接口
 * 
 * @author ruoyi
 * @date 2024-07-11
 */
public interface JingfeiDeptMapper 
{
    /**
     * 查询jingfeidept
     * 
     * @param id jingfeidept主键
     * @return jingfeidept
     */
    public JingfeiDept selectJingfeiDeptById(String id);

    /**
     * 查询jingfeidept列表
     * 
     * @param jingfeiDept jingfeidept
     * @return jingfeidept集合
     */
    public List<JingfeiDept> selectJingfeiDeptList(JingfeiDept jingfeiDept);

    /**
     * 新增jingfeidept
     * 
     * @param jingfeiDept jingfeidept
     * @return 结果
     */
    public int insertJingfeiDept(JingfeiDept jingfeiDept);

    /**
     * 修改jingfeidept
     * 
     * @param jingfeiDept jingfeidept
     * @return 结果
     */
    public int updateJingfeiDept(JingfeiDept jingfeiDept);

    /**
     * 删除jingfeidept
     * 
     * @param id jingfeidept主键
     * @return 结果
     */
    public int deleteJingfeiDeptById(String id);

    /**
     * 批量删除jingfeidept
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteJingfeiDeptByIds(String[] ids);

    public List<Map<String,Object>> findDeptJFByPiciId(@Param("piciid")String piciid);

    //有确认与延时条件
    public List<Map<String,Object>> findDeptJFByPiciIdTiaojian(@Param("piciid")String piciid);

    public List<Map<String,Object>> findMXByParentId(@Param("piciid")String piciid,@Param("deptid")String deptid,@Param("isshangjifafang")int isshangjifafang,
                                                     @Param("isshoukuan")int isshoukuan,@Param("deptname")String deptname);

    public int insertBatch(List<JingfeiDept> newJingfeiDeptList);

    public int UpdateFafangByIds(@Param("ids") List<String> ids);

    public List<Map<String,Object>> findDeptJFByParentId(@Param("piciid")String piciid,@Param("deptid")String deptid);

    public List<Map<String,Object>> findFFByPiciIdAndDeptId(@Param("piciid")String piciid,@Param("deptid")String deptid);

    public List<Map<String,Object>> findDWByPiciNameAndDeptId(@Param("deptid")String deptid,@Param("piciname")String piciname);

    public Object countFafangByIds(@Param("ids") List<String> ids);
}
